question about OLEDB
-
recently i work on oledb&sqlserver, for some reason , i use many unregular table name just like guid, for example: 4DACE4ED-55A9-4F9C-9270-CE73CBF067F3. there is no problem on my computer at all, but yesterday i install the application on an other machine, it does not work anymore,so i debuged the program on that machine and found that creating table is ok, but error occurs while opening a table with such unregular name. can anyone please tell me what the reason? should i need any aditional package? many thanks
-
recently i work on oledb&sqlserver, for some reason , i use many unregular table name just like guid, for example: 4DACE4ED-55A9-4F9C-9270-CE73CBF067F3. there is no problem on my computer at all, but yesterday i install the application on an other machine, it does not work anymore,so i debuged the program on that machine and found that creating table is ok, but error occurs while opening a table with such unregular name. can anyone please tell me what the reason? should i need any aditional package? many thanks
-
You might find that the problem occurs because the tablename begins with a digit not a letter. You can also try quoting the name, as in SELECT a,b,c FROM [4DACE4ED-55A9-4F9C-9270-CE73CBF067F3] and see if that helps... Steve S