|
1 - Check that Sql2k permit Mixed Mode auth ( simply verify that you can connect by (sa , xxxx) using QueryAnalyser
2 - Check the authentication mode on your DSN system source
3 - Please post the connection string. I think that can be more useful using a DSN-LESS connection string, using OleDb provider. For example: try:
"DRIVER=SQL Server;SERVER=YOURSERVERNAME;UID=sa;PWD=xxxx;DATABASE=YOURCATALOGNAME"
Hope this can help you.
Giacomo
|
|
|
|
|
can it be used with dsn connecttion to sql on another server
what changes should be done
|
|
|
|
|
Take a look at config.asp, should be pretty obvious I think
|
|
|
|
|
Please i changed the config.asp
as follows
case 'connstr': return 'DSN=xxxx';
i created a system data source pointing to a database on sql server 2000 on another server
I usedbut i got the error message microsoft ole db provider
with sql authentication using loginid i entered the sa and its corresponding password
but i got the following error message oledb provider for odbc driver error 80040e4d login failed for user null reason not associated with a trusted sql server connection
Help please
|
|
|
|
|
Is your sql server set up to use only windows authenticationand not sql server authentication? I believe this is the default for MSDE2000.
|
|
|
|
|
My sql 2000 is setup to use windows and sql (equivalent to mixed mode in sql 7)
|
|
|
|
|
And you don't have anything like "Trusted Connections" or something similar in the connection string?
|
|
|
|
|
can we add grid.setlookup(xxxx) how to write it so that we can have for example gender field do have a combo box male, female
|
|
|
|
|
If you put male and female into a recordset that should work.
|
|
|
|
|
Lookup is lost on using views or selecting particular records in a table
select * from table where field1='x'
i also tried to use views
|
|
|
|
|
Lookup depends on foreign keys, and views have no foreign keys.
|
|
|
|
|
can we filter a table and still make use of foreign keys thanks for your reply
|
|
|
|
|
I guess a recordset created from a select statement instead of a table can be used instead, but this application only supports tables (and views), and not select statements.
|
|
|
|
|
thanks the lookup box shows up but on clicking add without disabling the lookup an error message is displayed infront of the field name of the foreign key instead of a text box
microsoft ole db provider for sql server error 80040e14 invalid column name '2' where 2 is the value of the primary key of the related table
|
|
|
|
|
Probably a bug in my code. Doesn't the error message tell you what line (and file) this happens on?
|
|
|
|
|
No it doesn't tell the line number.
The data entry form displays properly for all the other fields which are not foreign keys only the one that is a foreign key got that error message instead of the input text box
|
|
|
|
|
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Invalid column name '6'.
/netdb/b.grid.asp, line 422
POST Data:
Category=6&action=add&pageno=0&sort=&sortfield=&sortorder=ASC¶m=&id=
two tables
table1 got the fields id , category_id, description,date,...
category got the fields category_ID, category
category_id in table1 is the foreign key
|
|
|
|
|
In data.asp, change line no 62 (or there about) from:
Grid.SetDefault(rsKeys('FK_COLUMN_NAME').Value,'select "' + dd.GetValue() + '"');
to
Grid.SetDefault(rsKeys('FK_COLUMN_NAME').Value,"select '" + dd.GetValue() + "'");
|
|
|
|
|
on using sql northwind database with the new version of dbgrid
the combo boxes for categories and products doesn't show while it works fine for access
please help
|
|
|
|
|
It works fine for me on WinXP and MSDE2000, with this connection string:
"Provider=SQLOLEDB.1;User ID=sa;Password=;Initial Catalog=testing;Data Source=localhost"
|
|
|
|
|
oes it need ado.net and windows 2000 or it works with windows nt and sql 7
I got error on using it with nt and sql 7 in data.asp?table=xxx
microsoft jcript compilation erro 800a03ea syntax error try {
i made no changes it worked fine on windows 2000 server that got sql 7 and ado.net except the combo boxes that are displayed for foreign keys they did not show for sql
|
|
|
|
|
To display the combo boxes it needs to find the foreign keys. It could be your connection string, or it could be that the driver doesn't report foreign keys the way I try to find them.
|
|
|
|
|
Hello
Im trying to get this thing to work, but I cant. I changed the
case 'database' in config.asp to read:
return 'd:\\inetpub\\wwwroot\\afclansite.com\\database\\myweb.mdb';
Now when I try to tun default.asp I get the following message:
Microsoft JScript runtime error '800a1391'
'adUseClient' is undefined
/netdb/common.asp, line 31
The config file is all I changed. Am I missing something?
|
|
|
|
|
The directory where the files are unzipped to needs to be an "application", or you need to insert the contents of the global.asa file into the global.asa in your wwwroot folder.
|
|
|
|
|
I have the same problem on "brinkster" and have put contents of global.asa in same file on root but still the same result....any suggestions
|
|
|
|