|
The file shouldn't be there, and therefore the link shouldn't have been there either.
|
|
|
|
|
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 used but 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
|
|
|
|
|
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?
|
|
|
|